package com.mav01.mrpbackend.mapper;

import com.mav01.mrpbackend.pojo.Store;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface StoreMapper {

    @Select("SELECT * FROM Store WHERE material_no = #{materialNo}")
    Store selectByMaterialNo(String materialNo);

    @Select("SELECT * FROM Store")
    List<Store> selectAll();
}